﻿
INSERT INTO [XyzDB].[dbo].[Customers]
           ([UserName]
           ,[Password]
           ,[RoleId]
           ,[FirstName]
           ,[LastName]
           ,[Gender]
           ,[DateOfBirth])
     VALUES
           ('user'
           ,'user'
           ,1
           ,'Pitoy'
           ,'Moreno'
           ,'M'
           ,'03-DEC-1980')

INSERT INTO [XyzDB].[dbo].[Members]
           ([CustomerId]
           ,[PassportNo]
           ,[Address1]
           ,[Address2]
           ,[Address3]
           ,[City]
           ,[PostalCode]
           ,[Country]
           ,[PassportExpiryDate]
           ,[MemberPoints])
     VALUES
           ((SELECT [CustomerId] FROM [dbo].[Customers] WHERE ( [UserName] = 'user'))
           ,'WW019019'
           ,'Somewhere'
           ,'Down'
           ,'The Road'
           ,'Singapore'
           ,'510122'
           ,'Singapore'
           ,'13-DEC-2020'
           ,50000)